Parents going on vacation with their children tend to experience “more mystery and mayhem than magic”, according to a survey released on Thursday.